<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="fb138336">gpexpand.status_detail</title>
  <body>
    <p>The <codeph>gpexpand.status_detail</codeph> table contains information about the status of
      tables involved in a system expansion operation. You can query this table to determine the
      status of tables being expanded, or to view the start and end time for completed tables. </p>
    <p>This table also stores related information about the table such as the oid and disk size.
      Overall status information for the expansion is stored in
        <xref href="gp_expansion_status.xml#topic1" type="topic" format="dita"/>.</p>
    <p>In a normal expansion operation it is not necessary to modify the data stored in this
      table.</p>
    <table id="fb138428">
      <title>gpexpand.status_detail</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="97pt"/>
        <colspec colnum="3" colname="col3" colwidth="82pt"/>
        <colspec colnum="4" colname="col4" colwidth="138pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>dbname</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">Name of the database to which the table belongs. </entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>fq_name</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">Fully qualified name of the table.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>table_oid</codeph>
            </entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3"/>
            <entry colname="col4">OID of the table.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>root_partition_oid</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">For a partitioned table, the OID of the root partition.
              Otherwise, <codeph>None</codeph>.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rank</codeph>
            </entry>
            <entry colname="col2">int</entry>
            <entry colname="col3"/>
            <entry colname="col4">Rank determines the order in which tables are expanded. The
              expansion utility will sort on rank and expand the lowest-ranking tables
              first.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>external_writable</codeph>
            </entry>
            <entry colname="col2">boolean</entry>
            <entry colname="col3"/>
            <entry colname="col4">Identifies whether or not the table is an external
              writable table. (External writable tables require a different syntax
              to expand).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>status</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">Status of expansion for this table. Valid values are:<p>NOT
                STARTED</p><p>IN PROGRESS</p><p>COMPLETED</p><p>NO LONGER EXISTS</p></entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>expansion_started</codeph>
            </entry>
            <entry colname="col2">timestamp without time zone</entry>
            <entry colname="col3"/>
            <entry colname="col4">Timestamp for the start of the expansion of this table. This field
              is only populated after a table is successfully expanded.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>expansion_finished</codeph>
            </entry>
            <entry colname="col2">timestamp without time zone</entry>
            <entry colname="col3"/>
            <entry colname="col4">Timestamp for the completion of expansion of this table.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>source_bytes</codeph>
            </entry>
            <entry colname="col2"/>
            <entry colname="col3"/>
            <entry colname="col4">The size of disk space associated with the source table. Due to
              table bloat in heap tables and differing numbers of segments after expansion, it is
              not expected that the final number of bytes will equal the source number. This
              information is tracked to help provide progress measurement to aid in duration
              estimation for the end-to-end expansion operation.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rel_storage</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">Storage type of a relation</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
